| Number of Variables | 23 |
|---|---|
| Number of Rows | 3817 |
| Missing Cells | 5859 |
| Missing Cells (%) | 6.7% |
| Duplicate Rows | 4 |
| Duplicate Rows (%) | 0.1% |
| Total Size in Memory | 2.3 MB |
| Average Row Size in Memory | 630.7 B |
| Variable Types |
|
| super_builtup_area has 1923 (50.38%) missing values | Missing |
|---|---|
| builtup_area has 2018 (52.87%) missing values | Missing |
| carpet_area has 1896 (49.67%) missing values | Missing |
| price is skewed | Skewed |
| price_per_sqft is skewed | Skewed |
| area is skewed | Skewed |
| bedRoom is skewed | Skewed |
| bathroom is skewed | Skewed |
| floorNum is skewed | Skewed |
| super_builtup_area is skewed | Skewed |
| builtup_area is skewed | Skewed |
|---|---|
| carpet_area is skewed | Skewed |
| luxury_score is skewed | Skewed |
| society has a high cardinality: 723 distinct values | High Cardinality |
| sector has a high cardinality: 189 distinct values | High Cardinality |
| areaWithType has a high cardinality: 2436 distinct values | High Cardinality |
| study room has constant length 1 | Constant Length |
| servant room has constant length 1 | Constant Length |
| store room has constant length 1 | Constant Length |
| pooja room has constant length 1 | Constant Length |
| others has constant length 1 | Constant Length |
|---|---|
| furnishing_type has constant length 1 | Constant Length |
| luxury_score has 530 (13.89%) zeros | Zeros |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 264318 |
| Mean | 4.2476 |
|---|---|
| Standard Deviation | 0.4317 |
| Median | 4 |
| Minimum | 4 |
| Maximum | 5 |
| 1st row | flat |
|---|---|
| 2nd row | flat |
| 3rd row | flat |
| 4th row | flat |
| 5th row | flat |
| Count | 16213 |
|---|---|
| Lowercase Letter | 16213 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 723 |
|---|---|
| Approximate Unique (%) | 18.9% |
| Missing | 1 |
| Missing (%) | 0.0% |
| Memory Size | 312038 |
| Mean | 16.771 |
|---|---|
| Standard Deviation | 6.4163 |
| Median | 15 |
| Minimum | 1 |
| Maximum | 49 |
| 1st row | dlf regal gardens |
|---|---|
| 2nd row | tulip violet |
| 3rd row | experion the heart... |
| 4th row | signature global c... |
| 5th row | puri diplomatic gr... |
| Count | 57314 |
|---|---|
| Lowercase Letter | 57314 |
| Space Separator | 6110 |
| Uppercase Letter | 0 |
| Dash Punctuation | 11 |
| Decimal Number | 548 |
categorical
| Approximate Distinct Count | 189 |
|---|---|
| Approximate Unique (%) | 5.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 285256 |
| Mean | 9.733 |
|---|---|
| Standard Deviation | 2.3345 |
| Median | 9 |
| Minimum | 6 |
| Maximum | 41 |
| 1st row | sector 90 |
|---|---|
| 2nd row | sector 69 |
| 3rd row | sector 108 |
| 4th row | sector 92 |
| 5th row | sector 111 |
| Count | 25423 |
|---|---|
| Lowercase Letter | 25413 |
| Space Separator | 4111 |
| Uppercase Letter | 10 |
| Dash Punctuation | 61 |
| Decimal Number | 7549 |
numerical
| Approximate Distinct Count | 479 |
|---|---|
| Approximate Unique (%) | 12.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 61072 |
| Mean | 2.5019 |
| Minimum | 0.07 |
| Maximum | 31.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0.07 |
|---|---|
| 5-th Percentile | 0.37 |
| Q1 | 0.92 |
| Median | 1.5 |
| Q3 | 2.7 |
| 95-th Percentile | 8.49 |
| Maximum | 31.5 |
| Range | 31.43 |
| IQR | 1.78 |
| Mean | 2.5019 |
|---|---|
| Standard Deviation | 2.9509 |
| Variance | 8.7077 |
| Sum | 9549.72 |
| Skewness | 3.2991 |
| Kurtosis | 15.1544 |
| Coefficient of Variation | 1.1795 |
numerical
| Approximate Distinct Count | 2731 |
|---|---|
| Approximate Unique (%) | 71.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 61072 |
| Mean | 14014.4021 |
| Minimum | 2 |
| Maximum | 600000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 2 |
|---|---|
| 5-th Percentile | 4666 |
| Q1 | 6808 |
| Median | 9016 |
| Q3 | 13888 |
| 95-th Percentile | 33333 |
| Maximum | 600000 |
| Range | 599998 |
| IQR | 7080 |
| Mean | 14014.4021 |
|---|---|
| Standard Deviation | 23332.3012 |
| Variance | 5.444e+08 |
| Sum | 5.3493e+07 |
| Skewness | 11.0005 |
| Kurtosis | 176.0118 |
| Coefficient of Variation | 1.6649 |
numerical
| Approximate Distinct Count | 1351 |
|---|---|
| Approximate Unique (%) | 35.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 61072 |
| Mean | 4745.7047 |
| Minimum | 45 |
| Maximum | 7.25e+06 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 45 |
|---|---|
| 5-th Percentile | 500 |
| Q1 | 1200 |
| Median | 1711 |
| Q3 | 2295 |
| 95-th Percentile | 4246.8 |
| Maximum | 7.25e+06 |
| Range | 7.25e+06 |
| IQR | 1095 |
| Mean | 4745.7047 |
|---|---|
| Standard Deviation | 119479.4308 |
| Variance | 1.4275e+10 |
| Sum | 1.8114e+07 |
| Skewness | 58.6487 |
| Kurtosis | 3542.7043 |
| Coefficient of Variation | 25.1763 |
categorical
| Approximate Distinct Count | 2436 |
|---|---|
| Approximate Unique (%) | 63.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 437722 |
| Mean | 49.677 |
|---|---|
| Standard Deviation | 25.8986 |
| Median | 38 |
| Minimum | 12 |
| Maximum | 108 |
| 1st row | super built up are... |
|---|---|
| 2nd row | super built up are... |
| 3rd row | super built up are... |
| 4th row | super built up are... |
| 5th row | super built up are... |
| Count | 85831 |
|---|---|
| Lowercase Letter | 85831 |
| Space Separator | 23380 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 48539 |
numerical
| Approximate Distinct Count | 21 |
|---|---|
| Approximate Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 61072 |
| Mean | 3.3725 |
| Minimum | 1 |
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 1 |
|---|---|
| 5-th Percentile | 2 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 4 |
| 95-th Percentile | 6 |
| Maximum | 36 |
| Range | 35 |
| IQR | 2 |
| Mean | 3.3725 |
|---|---|
| Standard Deviation | 2.0157 |
| Variance | 4.063 |
| Sum | 12873 |
| Skewness | 4.7808 |
| Kurtosis | 44.6118 |
| Coefficient of Variation | 0.5977 |
numerical
| Approximate Distinct Count | 21 |
|---|---|
| Approximate Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 61072 |
| Mean | 3.415 |
| Minimum | 1 |
| Maximum | 36 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 1 |
|---|---|
| 5-th Percentile | 1 |
| Q1 | 2 |
| Median | 3 |
| Q3 | 4 |
| 95-th Percentile | 6 |
| Maximum | 36 |
| Range | 35 |
| IQR | 2 |
| Mean | 3.415 |
|---|---|
| Standard Deviation | 2.0522 |
| Variance | 4.2114 |
| Sum | 13035 |
| Skewness | 4.5387 |
| Kurtosis | 42.3201 |
| Coefficient of Variation | 0.6009 |
categorical
| Approximate Distinct Count | 5 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 253107 |
| Mean | 1.3105 |
|---|---|
| Standard Deviation | 0.4627 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 2 |
| 1st row | 3 |
|---|---|
| 2nd row | 1 |
| 3rd row | 3+ |
| 4th row | 2 |
| 5th row | 3+ |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 3817 |
numerical
| Approximate Distinct Count | 44 |
|---|---|
| Approximate Unique (%) | 1.2% |
| Missing | 21 |
| Missing (%) | 0.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 60736 |
| Mean | 6.6707 |
| Minimum | 0 |
| Maximum | 51 |
| Zeros | 134 |
| Zeros (%) | 3.5% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 1 |
| Q1 | 2 |
| Median | 4 |
| Q3 | 10 |
| 95-th Percentile | 18 |
| Maximum | 51 |
| Range | 51 |
| IQR | 8 |
| Mean | 6.6707 |
|---|---|
| Standard Deviation | 6.0043 |
| Variance | 36.0512 |
| Sum | 25322 |
| Skewness | 1.7417 |
| Kurtosis | 4.7341 |
| Coefficient of Variation | 0.9001 |
categorical
| Approximate Distinct Count | 9 |
|---|---|
| Approximate Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 281074 |
| Mean | 8.6374 |
|---|---|
| Standard Deviation | 3.6554 |
| Median | 10 |
| Minimum | 4 |
| Maximum | 13 |
| 1st row | North-East |
|---|---|
| 2nd row | North-East |
| 3rd row | North |
| 4th row | not available |
| 5th row | North |
| Count | 30680 |
|---|---|
| Lowercase Letter | 26798 |
| Space Separator | 1112 |
| Uppercase Letter | 3882 |
| Dash Punctuation | 1177 |
| Decimal Number | 0 |
categorical
| Approximate Distinct Count | 6 |
|---|---|
| Approximate Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 299053 |
| Mean | 13.3477 |
|---|---|
| Standard Deviation | 1.9704 |
| Median | 14 |
| Minimum | 9 |
| Maximum | 18 |
| 1st row | Relatively New |
|---|---|
| 2nd row | Relatively New |
| 3rd row | Relatively New |
| 4th row | New Property |
| 5th row | Relatively New |
| Count | 47463 |
|---|---|
| Lowercase Letter | 40161 |
| Space Separator | 3485 |
| Uppercase Letter | 7302 |
| Dash Punctuation | 0 |
| Decimal Number | 0 |
numerical
| Approximate Distinct Count | 589 |
|---|---|
| Approximate Unique (%) | 31.1% |
| Missing | 1923 |
| Missing (%) | 50.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 30304 |
| Mean | 1924.0799 |
| Minimum | 325 |
| Maximum | 9997 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 325 |
|---|---|
| 5-th Percentile | 793 |
| Q1 | 1478.25 |
| Median | 1828 |
| Q3 | 2215 |
| 95-th Percentile | 3184 |
| Maximum | 9997 |
| Range | 9672 |
| IQR | 736.75 |
| Mean | 1924.0799 |
|---|---|
| Standard Deviation | 760.5025 |
| Variance | 578364.0799 |
| Sum | 3.6442e+06 |
| Skewness | 1.8654 |
| Kurtosis | 10.3916 |
| Coefficient of Variation | 0.3953 |
numerical
| Approximate Distinct Count | 653 |
|---|---|
| Approximate Unique (%) | 36.3% |
| Missing | 2018 |
| Missing (%) | 52.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 28784 |
| Mean | 7312.9423 |
| Minimum | 45 |
| Maximum | 8.7088e+06 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 45 |
|---|---|
| 5-th Percentile | 450 |
| Q1 | 1170 |
| Median | 1700 |
| Q3 | 2430 |
| 95-th Percentile | 4517 |
| Maximum | 8.7088e+06 |
| Range | 8.7088e+06 |
| IQR | 1260 |
| Mean | 7312.9423 |
|---|---|
| Standard Deviation | 206016.0423 |
| Variance | 4.2443e+10 |
| Sum | 1.3156e+07 |
| Skewness | 41.9441 |
| Kurtosis | 1768.1347 |
| Coefficient of Variation | 28.1714 |
numerical
| Approximate Distinct Count | 705 |
|---|---|
| Approximate Unique (%) | 36.7% |
| Missing | 1896 |
| Missing (%) | 49.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 30736 |
| Mean | 2771.2244 |
| Minimum | 15 |
| Maximum | 607716 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 15 |
|---|---|
| 5-th Percentile | 483 |
| Q1 | 900 |
| Median | 1350 |
| Q3 | 1800 |
| 95-th Percentile | 3155 |
| Maximum | 607716 |
| Range | 607701 |
| IQR | 900 |
| Mean | 2771.2244 |
|---|---|
| Standard Deviation | 22741.6039 |
| Variance | 5.1718e+08 |
| Sum | 5.3235e+06 |
| Skewness | 23.8815 |
| Kurtosis | 591.8569 |
| Coefficient of Variation | 8.2063 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 251922 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 3817 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 251922 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 3817 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 251922 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 3817 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 251922 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 3817 |
categorical
| Approximate Distinct Count | 2 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 251922 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 3817 |
categorical
| Approximate Distinct Count | 3 |
|---|---|
| Approximate Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory Size | 251922 |
| Mean | 1 |
|---|---|
| Standard Deviation | 0 |
| Median | 1 |
| Minimum | 1 |
| Maximum | 1 |
| 1st row | 1 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
| Count | 0 |
|---|---|
| Lowercase Letter | 0 |
| Space Separator | 0 |
| Uppercase Letter | 0 |
| Dash Punctuation | 0 |
| Decimal Number | 3817 |
numerical
| Approximate Distinct Count | 161 |
|---|---|
| Approximate Unique (%) | 4.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Memory Size | 61072 |
| Mean | 69.6398 |
| Minimum | 0 |
| Maximum | 174 |
| Zeros | 530 |
| Zeros (%) | 13.9% |
| Negatives | 0 |
| Negatives (%) | 0.0% |
| Minimum | 0 |
|---|---|
| 5-th Percentile | 0 |
| Q1 | 28 |
| Median | 56 |
| Q3 | 108 |
| 95-th Percentile | 174 |
| Maximum | 174 |
| Range | 174 |
| IQR | 80 |
| Mean | 69.6398 |
|---|---|
| Standard Deviation | 53.2699 |
| Variance | 2837.6813 |
| Sum | 265815 |
| Skewness | 0.4894 |
| Kurtosis | -0.8541 |
| Coefficient of Variation | 0.7649 |